Dataset statistics
| Number of variables | 30 |
|---|---|
| Number of observations | 168120 |
| Missing cells | 1686140 |
| Missing cells (%) | 33.4% |
| Duplicate rows | 540 |
| Duplicate rows (%) | 0.3% |
| Total size in memory | 91.5 MiB |
| Average record size in memory | 570.6 B |
Variable types
| NUM | 12 |
|---|---|
| CAT | 12 |
| UNSUPPORTED | 4 |
| BOOL | 2 |
Reproduction
| Analysis started | 2020-04-06 04:30:18.916567 |
|---|---|
| Analysis finished | 2020-04-06 04:32:46.054261 |
| Version | pandas-profiling v2.5.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
| Dataset has 540 (0.3%) duplicate rows | Duplicates |
NASC has a high cardinality: 32641 distinct values | High cardinality |
DT_INTER has a high cardinality: 4487 distinct values | High cardinality |
DIAG_PRINC has a high cardinality: 908 distinct values | High cardinality |
DIAG_SECUN has a high cardinality: 696 distinct values | High cardinality |
DIAGSEC1 has a high cardinality: 600 distinct values | High cardinality |
DIAGSEC2 has a high cardinality: 112 distinct values | High cardinality |
VAL_SH is highly correlated with UTI_MES_TO and 1 other fields | High Correlation |
UTI_MES_TO is highly correlated with VAL_SH | High Correlation |
VAL_SP is highly correlated with VAL_SH | High Correlation |
CGC_HOSP has 59129 (35.2%) missing values | Missing |
DIAG_SECUN has 84081 (50.0%) missing values | Missing |
ETNIA has 36659 (21.8%) missing values | Missing |
DIAGSEC1 has 161680 (96.2%) missing values | Missing |
DIAGSEC2 has 167827 (99.8%) missing values | Missing |
DIAGSEC3 has 168052 (> 99.9%) missing values | Missing |
DIAGSEC4 has 168113 (> 99.9%) missing values | Missing |
DIAGSEC5 has 168119 (> 99.9%) missing values | Missing |
DIAGSEC6 has 168120 (100.0%) missing values | Missing |
DIAGSEC7 has 168120 (100.0%) missing values | Missing |
DIAGSEC8 has 168120 (100.0%) missing values | Missing |
DIAGSEC9 has 168120 (100.0%) missing values | Missing |
MUNIC_RES is highly skewed (γ1 = 26.43076403) | Skewed |
UTI_INT_TO is highly skewed (γ1 = 69.38404365) | Skewed |
NACIONAL is highly skewed (γ1 = 72.1097067) | Skewed |
NASC only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
DT_INTER only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
DIAGSEC6 is an unsupported type, check if it needs cleaning or further analysis | Rejected |
DIAGSEC7 is an unsupported type, check if it needs cleaning or further analysis | Rejected |
DIAGSEC8 is an unsupported type, check if it needs cleaning or further analysis | Rejected |
DIAGSEC9 is an unsupported type, check if it needs cleaning or further analysis | Rejected |
UTI_MES_TO has 143218 (85.2%) zeros | Zeros |
UTI_INT_TO has 167961 (99.9%) zeros | Zeros |
DIAS_PERM has 2756 (1.6%) zeros | Zeros |
| Distinct count | 107 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 59129 |
| Missing (%) | 35.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13925397833063.29 |
|---|---|
| Minimum | 1431061000176.0 |
| Maximum | 73976722000150.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1.431061e+12 |
|---|---|
| 5-th percentile | 7.267476001e+12 |
| Q1 | 1.3937131e+13 |
| median | 1.393713101e+13 |
| Q3 | 1.5170723e+13 |
| 95-th percentile | 1.5180714e+13 |
| Maximum | 7.3976722e+13 |
| Range | 7.2545661e+13 |
| Interquartile range (IQR) | 1.233591999e+12 |
Descriptive statistics
| Standard deviation | 2.785869391e+12 |
|---|---|
| Coefficient of variation (CV) | 0.2000567183 |
| Kurtosis | 16.92654596 |
| Mean | 1.392539783e+13 |
| Median Absolute Deviation (MAD) | 1.160732682e+12 |
| Skewness | -1.937242346 |
| Sum | 1.517743035e+18 |
| Variance | 7.761068265e+24 |
| Value | Count | Frequency (%) | |
| 1.3937131e+13 | 20348 | 12.1% | |
| 1.5170723e+13 | 11069 | 6.6% | |
| 1.5180714e+13 | 9762 | 5.8% | |
| 1.393713101e+13 | 9570 | 5.7% | |
| 1.5178551e+13 | 8363 | 5.0% | |
| 1.3937131e+13 | 6100 | 3.6% | |
| 1.3937131e+13 | 5757 | 3.4% | |
| 1.5153745e+13 | 5613 | 3.3% | |
| 1.3937131e+13 | 5303 | 3.2% | |
| 1.393713101e+13 | 4026 | 2.4% | |
| Other values (97) | 23080 | 13.7% | |
| (Missing) | 59129 | 35.2% |
| Value | Count | Frequency (%) | |
| 1.431061e+12 | 2 | < 0.1% | |
| 2.106150001e+12 | 1023 | 0.6% | |
| 2.466144e+12 | 2401 | 1.4% | |
| 2.762633e+12 | 2 | < 0.1% | |
| 3.204913e+12 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 7.3976722e+13 | 1 | < 0.1% | |
| 6.3254312e+13 | 1 | < 0.1% | |
| 6.3103048e+13 | 1 | < 0.1% | |
| 6.3088645e+13 | 1 | < 0.1% | |
| 6.1986402e+13 | 1 | < 0.1% |
CEP
Real number (ℝ≥0)
| Distinct count | 18900 |
|---|---|
| Unique (%) | 11.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 42162280.73229241 |
|---|---|
| Minimum | 1001000 |
| Maximum | 98880000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1001000 |
|---|---|
| 5-th percentile | 40230320 |
| Q1 | 40715315 |
| median | 41310220 |
| Q3 | 42850000 |
| 95-th percentile | 47800114 |
| Maximum | 98880000 |
| Range | 97879000 |
| Interquartile range (IQR) | 2134685 |
Descriptive statistics
| Standard deviation | 2371603.988 |
|---|---|
| Coefficient of variation (CV) | 0.05624942358 |
| Kurtosis | 49.80638208 |
| Mean | 42162280.73 |
| Median Absolute Deviation (MAD) | 1702109.874 |
| Skewness | 1.499763734 |
| Sum | 7.088322637e+12 |
| Variance | 5.624505477e+12 |
| Value | Count | Frequency (%) | |
| 43700000 | 7373 | 4.4% | |
| 42700000 | 4497 | 2.7% | |
| 44470000 | 3175 | 1.9% | |
| 44460000 | 2987 | 1.8% | |
| 41250000 | 2929 | 1.7% | |
| 40415000 | 2464 | 1.5% | |
| 42802580 | 2440 | 1.5% | |
| 40050410 | 2002 | 1.2% | |
| 42850000 | 1947 | 1.2% | |
| 42820000 | 1783 | 1.1% | |
| Other values (18890) | 136523 | 81.2% |
| Value | Count | Frequency (%) | |
| 1001000 | 1 | < 0.1% | |
| 1310935 | 1 | < 0.1% | |
| 1509970 | 1 | < 0.1% | |
| 2325529 | 1 | < 0.1% | |
| 3242020 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 98880000 | 1 | < 0.1% | |
| 96880970 | 1 | < 0.1% | |
| 96880000 | 2 | < 0.1% | |
| 96504182 | 1 | < 0.1% | |
| 94960100 | 1 | < 0.1% |
| Distinct count | 553 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 292482.9683737806 |
|---|---|
| Minimum | 110080 |
| Maximum | 530180 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 110080 |
|---|---|
| 5-th percentile | 290570 |
| Q1 | 292740 |
| median | 292740 |
| Q3 | 292740 |
| 95-th percentile | 293070 |
| Maximum | 530180 |
| Range | 420100 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3626.159064 |
|---|---|
| Coefficient of variation (CV) | 0.0123978469 |
| Kurtosis | 2273.198726 |
| Mean | 292482.9684 |
| Median Absolute Deviation (MAD) | 615.2774989 |
| Skewness | 26.43076403 |
| Sum | 4.917223664e+10 |
| Variance | 13149029.56 |
| Value | Count | Frequency (%) | |
| 292740 | 111837 | 66.5% | |
| 293070 | 7452 | 4.4% | |
| 290570 | 6745 | 4.0% | |
| 291920 | 4980 | 3.0% | |
| 293320 | 3221 | 1.9% | |
| 291610 | 2998 | 1.8% | |
| 290650 | 2774 | 1.7% | |
| 291005 | 1994 | 1.2% | |
| 292100 | 1773 | 1.1% | |
| 292950 | 1430 | 0.9% | |
| Other values (543) | 22916 | 13.6% |
| Value | Count | Frequency (%) | |
| 110080 | 1 | < 0.1% | |
| 120040 | 5 | < 0.1% | |
| 130260 | 3 | < 0.1% | |
| 140010 | 1 | < 0.1% | |
| 150060 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 530180 | 1 | < 0.1% | |
| 530070 | 1 | < 0.1% | |
| 530010 | 2 | < 0.1% | |
| 521645 | 1 | < 0.1% | |
| 521250 | 1 | < 0.1% |
| Distinct count | 32641 |
|---|---|
| Unique (%) | 19.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 1993-04-16 | 125 |
|---|---|
| 1936-02-10 | 104 |
| 1920-10-12 | 97 |
| 1980-02-02 | 92 |
| 1963-05-01 | 66 |
| Other values (32636) |
| Value | Count | Frequency (%) | |
| 1993-04-16 | 125 | 0.1% | |
| 1936-02-10 | 104 | 0.1% | |
| 1920-10-12 | 97 | 0.1% | |
| 1980-02-02 | 92 | 0.1% | |
| 1963-05-01 | 66 | < 0.1% | |
| 2011-12-07 | 56 | < 0.1% | |
| 1980-07-11 | 52 | < 0.1% | |
| 2008-01-18 | 51 | < 0.1% | |
| 2006-05-28 | 50 | < 0.1% | |
| 2010-01-01 | 48 | < 0.1% | |
| Other values (32631) | 167379 | 99.6% |
Length
| Max length | 10 |
|---|---|
| Mean length | 10 |
| Min length | 10 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 90.9% | |
| Dash_Punctuation | 1 | 9.1% |
| Value | Count | Frequency (%) | |
| Common | 11 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 11 | 100.0% |
SEXO
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 1 | |
|---|---|
| 3 |
| Value | Count | Frequency (%) | |
| 1 | 90827 | 54.0% | |
| 3 | 77293 | 46.0% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 2 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 2 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 2 | 100.0% |
| Distinct count | 85 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.27984177968118 |
|---|---|
| Minimum | 0 |
| Maximum | 99 |
| Zeros | 143218 |
| Zeros (%) | 85.2% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 8 |
| Maximum | 99 |
| Range | 99 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 4.642449423 |
|---|---|
| Coefficient of variation (CV) | 3.627361988 |
| Kurtosis | 51.45973925 |
| Mean | 1.27984178 |
| Median Absolute Deviation (MAD) | 2.189940202 |
| Skewness | 5.990889602 |
| Sum | 215167 |
| Variance | 21.55233664 |
| Value | Count | Frequency (%) | |
| 0 | 143218 | 85.2% | |
| 2 | 2993 | 1.8% | |
| 1 | 2823 | 1.7% | |
| 3 | 2500 | 1.5% | |
| 7 | 2026 | 1.2% | |
| 4 | 2022 | 1.2% | |
| 5 | 1700 | 1.0% | |
| 6 | 1578 | 0.9% | |
| 8 | 1059 | 0.6% | |
| 9 | 822 | 0.5% | |
| Other values (75) | 7379 | 4.4% |
| Value | Count | Frequency (%) | |
| 0 | 143218 | 85.2% | |
| 1 | 2823 | 1.7% | |
| 2 | 2993 | 1.8% | |
| 3 | 2500 | 1.5% | |
| 4 | 2022 | 1.2% |
| Value | Count | Frequency (%) | |
| 99 | 1 | < 0.1% | |
| 96 | 2 | < 0.1% | |
| 93 | 1 | < 0.1% | |
| 92 | 3 | < 0.1% | |
| 91 | 1 | < 0.1% |
| Distinct count | 37 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.010022602902688556 |
|---|---|
| Minimum | 0 |
| Maximum | 66 |
| Zeros | 167961 |
| Zeros (%) | 99.9% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 66 |
| Range | 66 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.453869594 |
|---|---|
| Coefficient of variation (CV) | 45.28460305 |
| Kurtosis | 6362.349065 |
| Mean | 0.0100226029 |
| Median Absolute Deviation (MAD) | 0.02002624799 |
| Skewness | 69.38404365 |
| Sum | 1685 |
| Variance | 0.2059976083 |
| Value | Count | Frequency (%) | |
| 0 | 167961 | 99.9% | |
| 3 | 15 | < 0.1% | |
| 6 | 15 | < 0.1% | |
| 2 | 14 | < 0.1% | |
| 1 | 11 | < 0.1% | |
| 4 | 11 | < 0.1% | |
| 5 | 10 | < 0.1% | |
| 9 | 10 | < 0.1% | |
| 10 | 8 | < 0.1% | |
| 7 | 6 | < 0.1% | |
| Other values (27) | 59 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 167961 | 99.9% | |
| 1 | 11 | < 0.1% | |
| 2 | 14 | < 0.1% | |
| 3 | 15 | < 0.1% | |
| 4 | 11 | < 0.1% |
| Value | Count | Frequency (%) | |
| 66 | 1 | < 0.1% | |
| 54 | 1 | < 0.1% | |
| 42 | 1 | < 0.1% | |
| 37 | 1 | < 0.1% | |
| 36 | 1 | < 0.1% |
| Distinct count | 51772 |
|---|---|
| Unique (%) | 30.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1259.4719468831788 |
|---|---|
| Minimum | 19.03 |
| Maximum | 54514.88 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 19.03 |
|---|---|
| 5-th percentile | 160.62 |
| Q1 | 467.47 |
| median | 544.07 |
| Q3 | 896.4125 |
| 95-th percentile | 4986.065 |
| Maximum | 54514.88 |
| Range | 54495.85 |
| Interquartile range (IQR) | 428.9425 |
Descriptive statistics
| Standard deviation | 2438.11638 |
|---|---|
| Coefficient of variation (CV) | 1.935824284 |
| Kurtosis | 55.2629372 |
| Mean | 1259.471947 |
| Median Absolute Deviation (MAD) | 1200.528299 |
| Skewness | 6.042422989 |
| Sum | 211742423.7 |
| Variance | 5944411.484 |
| Value | Count | Frequency (%) | |
| 504.07 | 12829 | 7.6% | |
| 512.07 | 3364 | 2.0% | |
| 528.07 | 3135 | 1.9% | |
| 520.07 | 3046 | 1.8% | |
| 453.48 | 2710 | 1.6% | |
| 536.07 | 2546 | 1.5% | |
| 451.47 | 2097 | 1.2% | |
| 480.07 | 2074 | 1.2% | |
| 544.07 | 1694 | 1.0% | |
| 241.31 | 1557 | 0.9% | |
| Other values (51762) | 133068 | 79.2% |
| Value | Count | Frequency (%) | |
| 19.03 | 5 | < 0.1% | |
| 30.47 | 657 | 0.4% | |
| 31.47 | 38 | < 0.1% | |
| 33.34 | 582 | 0.3% | |
| 34.34 | 16 | < 0.1% |
| Value | Count | Frequency (%) | |
| 54514.88 | 1 | < 0.1% | |
| 53127.45 | 1 | < 0.1% | |
| 51369.08 | 1 | < 0.1% | |
| 51199.15 | 1 | < 0.1% | |
| 50812.25 | 1 | < 0.1% |
| Distinct count | 11052 |
|---|---|
| Unique (%) | 6.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 207.36150808945987 |
|---|---|
| Minimum | 5.1 |
| Maximum | 15383.27 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 5.1 |
|---|---|
| 5-th percentile | 25.71 |
| Q1 | 55.69 |
| median | 78.35 |
| Q3 | 173.29 |
| 95-th percentile | 852.6215 |
| Maximum | 15383.27 |
| Range | 15378.17 |
| Interquartile range (IQR) | 117.6 |
Descriptive statistics
| Standard deviation | 401.136689 |
|---|---|
| Coefficient of variation (CV) | 1.934479994 |
| Kurtosis | 85.73160157 |
| Mean | 207.3615081 |
| Median Absolute Deviation (MAD) | 206.6830184 |
| Skewness | 6.527403945 |
| Sum | 34861616.74 |
| Variance | 160910.6432 |
| Value | Count | Frequency (%) | |
| 78.35 | 47238 | 28.1% | |
| 25.71 | 8637 | 5.1% | |
| 26.51 | 7429 | 4.4% | |
| 29.4 | 5711 | 3.4% | |
| 183.91 | 5573 | 3.3% | |
| 74.62 | 4484 | 2.7% | |
| 117.52 | 4126 | 2.5% | |
| 24.1 | 1857 | 1.1% | |
| 44.1 | 1508 | 0.9% | |
| 9.91 | 1328 | 0.8% | |
| Other values (11042) | 80229 | 47.7% |
| Value | Count | Frequency (%) | |
| 5.1 | 5 | < 0.1% | |
| 5.32 | 60 | < 0.1% | |
| 5.34 | 1 | < 0.1% | |
| 5.58 | 4 | < 0.1% | |
| 5.59 | 224 | 0.1% |
| Value | Count | Frequency (%) | |
| 15383.27 | 1 | < 0.1% | |
| 14247.6 | 1 | < 0.1% | |
| 12311.11 | 1 | < 0.1% | |
| 12148.16 | 1 | < 0.1% | |
| 11945.28 | 1 | < 0.1% |
| Distinct count | 4487 |
|---|---|
| Unique (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 2008-01-01 | 215 |
|---|---|
| 2011-12-28 | 137 |
| 2012-12-01 | 126 |
| 2017-07-01 | 124 |
| 2017-05-01 | 119 |
| Other values (4482) |
| Value | Count | Frequency (%) | |
| 2008-01-01 | 215 | 0.1% | |
| 2011-12-28 | 137 | 0.1% | |
| 2012-12-01 | 126 | 0.1% | |
| 2017-07-01 | 124 | 0.1% | |
| 2017-05-01 | 119 | 0.1% | |
| 2017-06-01 | 118 | 0.1% | |
| 2019-06-01 | 116 | 0.1% | |
| 2014-08-01 | 115 | 0.1% | |
| 2016-09-01 | 112 | 0.1% | |
| 2015-05-01 | 107 | 0.1% | |
| Other values (4477) | 166831 | 99.2% |
Length
| Max length | 10 |
|---|---|
| Mean length | 10 |
| Min length | 10 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 90.9% | |
| Dash_Punctuation | 1 | 9.1% |
| Value | Count | Frequency (%) | |
| Common | 11 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 11 | 100.0% |
| Distinct count | 908 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| J189 | |
|---|---|
| J159 | |
| J960 | |
| J180 | 13980 |
| J188 | 10166 |
| Other values (903) |
| Value | Count | Frequency (%) | |
| J189 | 23922 | 14.2% | |
| J159 | 18419 | 11.0% | |
| J960 | 18136 | 10.8% | |
| J180 | 13980 | 8.3% | |
| J188 | 10166 | 6.0% | |
| J459 | 7228 | 4.3% | |
| J158 | 6832 | 4.1% | |
| J353 | 5880 | 3.5% | |
| J219 | 5413 | 3.2% | |
| J449 | 3318 | 2.0% | |
| Other values (898) | 54826 | 32.6% |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.928414228 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 21 | 67.7% | |
| Decimal_Number | 10 | 32.3% |
| Value | Count | Frequency (%) | |
| Latin | 21 | 67.7% | |
| Common | 10 | 32.3% |
| Value | Count | Frequency (%) | |
| ASCII | 31 | 100.0% |
| Distinct count | 696 |
|---|---|
| Unique (%) | 0.8% |
| Missing | 84081 |
| Missing (%) | 50.0% |
| Memory size | 1.3 MiB |
| 0000 | |
|---|---|
| Y099 | 1599 |
| J960 | 1276 |
| R060 | 1254 |
| J90 | 1059 |
| Other values (691) | 8593 |
| Value | Count | Frequency (%) | |
| 0000 | 70258 | 41.8% | |
| Y099 | 1599 | 1.0% | |
| J960 | 1276 | 0.8% | |
| R060 | 1254 | 0.7% | |
| J90 | 1059 | 0.6% | |
| A150 | 831 | 0.5% | |
| J189 | 606 | 0.4% | |
| J188 | 601 | 0.4% | |
| Y86 | 449 | 0.3% | |
| J450 | 448 | 0.3% | |
| Other values (686) | 5658 | 3.4% | |
| (Missing) | 84081 | 50.0% |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.486551273 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 25 | 67.6% | |
| Decimal_Number | 10 | 27.0% | |
| Lowercase_Letter | 2 | 5.4% |
| Value | Count | Frequency (%) | |
| Latin | 27 | 73.0% | |
| Common | 10 | 27.0% |
| Value | Count | Frequency (%) | |
| ASCII | 37 | 100.0% |
MUNIC_MOV
Real number (ℝ≥0)
| Distinct count | 135 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 292565.35914822744 |
|---|---|
| Minimum | 290070 |
| Maximum | 293340 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 290070 |
|---|---|
| 5-th percentile | 290839.5 |
| Q1 | 292740 |
| median | 292740 |
| Q3 | 292740 |
| 95-th percentile | 292740 |
| Maximum | 293340 |
| Range | 3270 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 543.5335622 |
|---|---|
| Coefficient of variation (CV) | 0.001857819271 |
| Kurtosis | 6.672429328 |
| Mean | 292565.3591 |
| Median Absolute Deviation (MAD) | 331.8710398 |
| Skewness | -2.764663583 |
| Sum | 4.918608818e+10 |
| Variance | 295428.7332 |
| Value | Count | Frequency (%) | |
| 292740 | 138234 | 82.2% | |
| 293070 | 6110 | 3.6% | |
| 291610 | 5757 | 3.4% | |
| 290570 | 5304 | 3.2% | |
| 291920 | 3280 | 2.0% | |
| 290650 | 3003 | 1.8% | |
| 292100 | 1471 | 0.9% | |
| 291005 | 1335 | 0.8% | |
| 292950 | 1081 | 0.6% | |
| 291992 | 1007 | 0.6% | |
| Other values (125) | 1538 | 0.9% |
| Value | Count | Frequency (%) | |
| 290070 | 18 | < 0.1% | |
| 290100 | 1 | < 0.1% | |
| 290110 | 1 | < 0.1% | |
| 290130 | 3 | < 0.1% | |
| 290160 | 10 | < 0.1% |
| Value | Count | Frequency (%) | |
| 293340 | 1 | < 0.1% | |
| 293330 | 10 | < 0.1% | |
| 293320 | 84 | < 0.1% | |
| 293310 | 1 | < 0.1% | |
| 293300 | 5 | < 0.1% |
| Distinct count | 135 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.085789911967643 |
|---|---|
| Minimum | 0 |
| Maximum | 347 |
| Zeros | 2756 |
| Zeros (%) | 1.6% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 5 |
| Q3 | 10 |
| 95-th percentile | 31 |
| Maximum | 347 |
| Range | 347 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 11.79771026 |
|---|---|
| Coefficient of variation (CV) | 1.298479315 |
| Kurtosis | 29.31916807 |
| Mean | 9.085789912 |
| Median Absolute Deviation (MAD) | 7.507054719 |
| Skewness | 3.712986324 |
| Sum | 1527503 |
| Variance | 139.1859674 |
| Value | Count | Frequency (%) | |
| 2 | 25475 | 15.2% | |
| 3 | 19525 | 11.6% | |
| 4 | 16805 | 10.0% | |
| 1 | 13402 | 8.0% | |
| 5 | 12840 | 7.6% | |
| 6 | 10475 | 6.2% | |
| 7 | 9399 | 5.6% | |
| 8 | 7384 | 4.4% | |
| 9 | 4984 | 3.0% | |
| 10 | 4355 | 2.6% | |
| Other values (125) | 43476 | 25.9% |
| Value | Count | Frequency (%) | |
| 0 | 2756 | 1.6% | |
| 1 | 13402 | 8.0% | |
| 2 | 25475 | 15.2% | |
| 3 | 19525 | 11.6% | |
| 4 | 16805 | 10.0% |
| Value | Count | Frequency (%) | |
| 347 | 1 | < 0.1% | |
| 338 | 1 | < 0.1% | |
| 309 | 1 | < 0.1% | |
| 308 | 1 | < 0.1% | |
| 304 | 1 | < 0.1% |
MORTE
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 0 | |
|---|---|
| 1 | 15737 |
| Value | Count | Frequency (%) | |
| 0 | 152383 | 90.6% | |
| 1 | 15737 | 9.4% |
| Distinct count | 31 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.078943611705924 |
|---|---|
| Minimum | 10 |
| Maximum | 339 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 10 |
| median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 339 |
| Range | 329 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.884344283 |
|---|---|
| Coefficient of variation (CV) | 0.2861752575 |
| Kurtosis | 6956.403672 |
| Mean | 10.07894361 |
| Median Absolute Deviation (MAD) | 0.1576486834 |
| Skewness | 72.1097067 |
| Sum | 1694472 |
| Variance | 8.319441945 |
| Value | Count | Frequency (%) | |
| 10 | 167866 | 99.8% | |
| 45 | 132 | 0.1% | |
| 35 | 16 | < 0.1% | |
| 81 | 15 | < 0.1% | |
| 71 | 14 | < 0.1% | |
| 39 | 12 | < 0.1% | |
| 37 | 7 | < 0.1% | |
| 100 | 6 | < 0.1% | |
| 21 | 5 | < 0.1% | |
| 110 | 5 | < 0.1% | |
| Other values (21) | 42 | < 0.1% |
| Value | Count | Frequency (%) | |
| 10 | 167866 | 99.8% | |
| 20 | 3 | < 0.1% | |
| 21 | 5 | < 0.1% | |
| 30 | 2 | < 0.1% | |
| 32 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 339 | 2 | < 0.1% | |
| 333 | 4 | < 0.1% | |
| 264 | 1 | < 0.1% | |
| 260 | 1 | < 0.1% | |
| 210 | 1 | < 0.1% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 168120 | 100.0% |
INSC_PN
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 0 | |
|---|---|
| 2 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 168119 | > 99.9% | |
| 2 | 1 | < 0.1% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 2 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 2 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 2 | 100.0% |
CNES
Real number (ℝ≥0)
| Distinct count | 200 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1748946.4465441352 |
|---|---|
| Minimum | 3778 |
| Maximum | 9443665 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 3778 |
|---|---|
| 5-th percentile | 3816 |
| Q1 | 4065 |
| median | 4294 |
| Q3 | 2802104 |
| 95-th percentile | 6595197 |
| Maximum | 9443665 |
| Range | 9439887 |
| Interquartile range (IQR) | 2798039 |
Descriptive statistics
| Standard deviation | 2306781.26 |
|---|---|
| Coefficient of variation (CV) | 1.318954771 |
| Kurtosis | 0.8510470548 |
| Mean | 1748946.447 |
| Median Absolute Deviation (MAD) | 1905419.7 |
| Skewness | 1.274228515 |
| Sum | 2.940328766e+11 |
| Variance | 5.32123978e+12 |
| Value | Count | Frequency (%) | |
| 2802104 | 23464 | 14.0% | |
| 4065 | 20348 | 12.1% | |
| 6595197 | 13958 | 8.3% | |
| 4278 | 11069 | 6.6% | |
| 3980 | 9980 | 5.9% | |
| 3816 | 9762 | 5.8% | |
| 3859 | 9570 | 5.7% | |
| 2532387 | 6110 | 3.6% | |
| 4073 | 6100 | 3.6% | |
| 2602083 | 5757 | 3.4% | |
| Other values (190) | 52002 | 30.9% |
| Value | Count | Frequency (%) | |
| 3778 | 656 | 0.4% | |
| 3786 | 1565 | 0.9% | |
| 3794 | 147 | 0.1% | |
| 3808 | 1709 | 1.0% | |
| 3816 | 9762 | 5.8% |
| Value | Count | Frequency (%) | |
| 9443665 | 1767 | 1.1% | |
| 9383298 | 2 | < 0.1% | |
| 7223676 | 5 | < 0.1% | |
| 7222955 | 497 | 0.3% | |
| 7187556 | 239 | 0.1% |
RACA_COR
Real number (ℝ≥0)
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 70.22539257673091 |
|---|---|
| Minimum | 1 |
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 99 |
| Q3 | 99 |
| 95-th percentile | 99 |
| Maximum | 99 |
| Range | 98 |
| Interquartile range (IQR) | 96 |
Descriptive statistics
| Standard deviation | 44.06951797 |
|---|---|
| Coefficient of variation (CV) | 0.6275439176 |
| Kurtosis | -1.227562598 |
| Mean | 70.22539258 |
| Median Absolute Deviation (MAD) | 40.34709319 |
| Skewness | -0.8787333434 |
| Sum | 11806293 |
| Variance | 1942.122414 |
| Value | Count | Frequency (%) | |
| 99 | 117867 | 70.1% | |
| 3 | 38179 | 22.7% | |
| 2 | 7593 | 4.5% | |
| 1 | 3398 | 2.0% | |
| 4 | 1076 | 0.6% | |
| 5 | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 3398 | 2.0% | |
| 2 | 7593 | 4.5% | |
| 3 | 38179 | 22.7% | |
| 4 | 1076 | 0.6% | |
| 5 | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 99 | 117867 | 70.1% | |
| 5 | 7 | < 0.1% | |
| 4 | 1076 | 0.6% | |
| 3 | 38179 | 22.7% | |
| 2 | 7593 | 4.5% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 36659 |
| Missing (%) | 21.8% |
| Memory size | 1.3 MiB |
| 0 | |
|---|---|
| 7 | 1 |
| Value | Count | Frequency (%) | |
| 0 | 131460 | 78.2% | |
| 7 | 1 | < 0.1% | |
| (Missing) | 36659 | 21.8% |
Length
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 2 | 40.0% | |
| Decimal_Number | 2 | 40.0% | |
| Other_Punctuation | 1 | 20.0% |
| Value | Count | Frequency (%) | |
| Common | 3 | 60.0% | |
| Latin | 2 | 40.0% |
| Value | Count | Frequency (%) | |
| ASCII | 5 | 100.0% |
| Distinct count | 600 |
|---|---|
| Unique (%) | 9.3% |
| Missing | 161680 |
| Missing (%) | 96.2% |
| Memory size | 1.3 MiB |
| J960 | |
|---|---|
| Y86 | |
| A419 | 481 |
| J159 | 378 |
| J969 | 286 |
| Other values (595) |
| Value | Count | Frequency (%) | |
| J960 | 1117 | 0.7% | |
| Y86 | 1030 | 0.6% | |
| A419 | 481 | 0.3% | |
| J159 | 378 | 0.2% | |
| J969 | 286 | 0.2% | |
| R579 | 223 | 0.1% | |
| J342 | 178 | 0.1% | |
| J189 | 167 | 0.1% | |
| J158 | 108 | 0.1% | |
| N179 | 86 | 0.1% | |
| Other values (590) | 2386 | 1.4% | |
| (Missing) | 161680 | 96.2% |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.030145134 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 24 | 66.7% | |
| Decimal_Number | 10 | 27.8% | |
| Lowercase_Letter | 2 | 5.6% |
| Value | Count | Frequency (%) | |
| Latin | 26 | 72.2% | |
| Common | 10 | 27.8% |
| Value | Count | Frequency (%) | |
| ASCII | 36 | 100.0% |
| Distinct count | 112 |
|---|---|
| Unique (%) | 38.2% |
| Missing | 167827 |
| Missing (%) | 99.8% |
| Memory size | 1.3 MiB |
| J960 | |
|---|---|
| I10 | 18 |
| J159 | 16 |
| A419 | 12 |
| J969 | 12 |
| Other values (107) |
| Value | Count | Frequency (%) | |
| J960 | 56 | < 0.1% | |
| I10 | 18 | < 0.1% | |
| J159 | 16 | < 0.1% | |
| A419 | 12 | < 0.1% | |
| J969 | 12 | < 0.1% | |
| J189 | 11 | < 0.1% | |
| R579 | 10 | < 0.1% | |
| N179 | 7 | < 0.1% | |
| J348 | 5 | < 0.1% | |
| J342 | 5 | < 0.1% | |
| Other values (102) | 141 | 0.1% | |
| (Missing) | 167827 | 99.8% |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.001498929 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 18 | 60.0% | |
| Decimal_Number | 10 | 33.3% | |
| Lowercase_Letter | 2 | 6.7% |
| Value | Count | Frequency (%) | |
| Latin | 20 | 66.7% | |
| Common | 10 | 33.3% |
| Value | Count | Frequency (%) | |
| ASCII | 30 | 100.0% |
| Distinct count | 33 |
|---|---|
| Unique (%) | 48.5% |
| Missing | 168052 |
| Missing (%) | > 99.9% |
| Memory size | 1.3 MiB |
| J960 | |
|---|---|
| J159 | 6 |
| N179 | 5 |
| A419 | 5 |
| R579 | 4 |
| Other values (28) |
| Value | Count | Frequency (%) | |
| J960 | 15 | < 0.1% | |
| J159 | 6 | < 0.1% | |
| N179 | 5 | < 0.1% | |
| A419 | 5 | < 0.1% | |
| R579 | 4 | < 0.1% | |
| R578 | 3 | < 0.1% | |
| J189 | 3 | < 0.1% | |
| R570 | 2 | < 0.1% | |
| I509 | 1 | < 0.1% | |
| A418 | 1 | < 0.1% | |
| Other values (23) | 23 | < 0.1% | |
| (Missing) | 168052 | > 99.9% |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.000392577 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 12 | 50.0% | |
| Decimal_Number | 10 | 41.7% | |
| Lowercase_Letter | 2 | 8.3% |
| Value | Count | Frequency (%) | |
| Latin | 14 | 58.3% | |
| Common | 10 | 41.7% |
| Value | Count | Frequency (%) | |
| ASCII | 24 | 100.0% |
| Distinct count | 5 |
|---|---|
| Unique (%) | 71.4% |
| Missing | 168113 |
| Missing (%) | > 99.9% |
| Memory size | 1.3 MiB |
| R579 | |
|---|---|
| G736 | |
| J960 | |
| E877 | |
| A419 |
| Value | Count | Frequency (%) | |
| R579 | 3 | < 0.1% | |
| G736 | 1 | < 0.1% | |
| J960 | 1 | < 0.1% | |
| E877 | 1 | < 0.1% | |
| A419 | 1 | < 0.1% | |
| (Missing) | 168113 | > 99.9% |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.000041637 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 9 | 56.2% | |
| Uppercase_Letter | 5 | 31.2% | |
| Lowercase_Letter | 2 | 12.5% |
| Value | Count | Frequency (%) | |
| Common | 9 | 56.2% | |
| Latin | 7 | 43.8% |
| Value | Count | Frequency (%) | |
| ASCII | 16 | 100.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 168119 |
| Missing (%) | > 99.9% |
| Memory size | 1.3 MiB |
| B961 |
|---|
| Value | Count | Frequency (%) | |
| B961 | 1 | < 0.1% | |
| (Missing) | 168119 | > 99.9% |
Length
| Max length | 4 |
|---|---|
| Mean length | 3.000005948 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 3 | 50.0% | |
| Lowercase_Letter | 2 | 33.3% | |
| Uppercase_Letter | 1 | 16.7% |
| Value | Count | Frequency (%) | |
| Common | 3 | 50.0% | |
| Latin | 3 | 50.0% |
| Value | Count | Frequency (%) | |
| ASCII | 6 | 100.0% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
First rows
| CGC_HOSP | CEP | MUNIC_RES | NASC | SEXO | UTI_MES_TO | UTI_INT_TO | VAL_SH | VAL_SP | DT_INTER | DIAG_PRINC | DIAG_SECUN | MUNIC_MOV | DIAS_PERM | MORTE | NACIONAL | INSTRU | INSC_PN | CNES | RACA_COR | ETNIA | DIAGSEC1 | DIAGSEC2 | DIAGSEC3 | DIAGSEC4 | DIAGSEC5 | DIAGSEC6 | DIAGSEC7 | DIAGSEC8 | DIAGSEC9 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | NaN | 43805140 | 290650 | 1932-12-22 | 3 | 0 | 0 | 536.07 | 74.62 | 2008-01-14 | J189 | NaN | 290650 | 7 | 0 | 10 | 0 | 0 | 2387581 | 99 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | NaN | 43805140 | 290650 | 1980-08-30 | 1 | 0 | 0 | 577.97 | 74.62 | 2008-01-12 | J188 | NaN | 290650 | 8 | 0 | 10 | 0 | 0 | 2387581 | 99 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2 | NaN | 40353000 | 292740 | 2006-08-23 | 1 | 0 | 0 | 436.25 | 24.49 | 2008-01-05 | J459 | NaN | 290780 | 3 | 0 | 10 | 0 | 0 | 2532522 | 3 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 3 | NaN | 43805140 | 290650 | 1968-10-23 | 3 | 0 | 0 | 544.12 | 33.18 | 2007-12-25 | J81 | NaN | 290650 | 4 | 0 | 10 | 0 | 0 | 2387581 | 99 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 4 | NaN | 43805140 | 290650 | 2008-01-12 | 3 | 0 | 0 | 504.07 | 74.62 | 2008-01-13 | J188 | NaN | 290650 | 3 | 0 | 10 | 0 | 0 | 2387581 | 99 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 5 | NaN | 43805140 | 290650 | 1937-04-24 | 1 | 0 | 0 | 497.65 | 24.49 | 2008-01-12 | J448 | NaN | 290650 | 4 | 0 | 10 | 0 | 0 | 2387581 | 99 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 6 | NaN | 43700000 | 293070 | 2002-10-16 | 3 | 0 | 0 | 412.25 | 24.49 | 2008-01-06 | J459 | NaN | 293070 | 1 | 0 | 10 | 0 | 0 | 2532387 | 3 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 7 | NaN | 43700000 | 293070 | 1995-12-06 | 1 | 0 | 0 | 429.97 | 28.00 | 2008-01-03 | J960 | NaN | 293070 | 0 | 1 | 10 | 0 | 0 | 2532387 | 3 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 8 | NaN | 43700000 | 293070 | 2003-02-06 | 1 | 0 | 0 | 412.25 | 24.49 | 2008-01-03 | J459 | NaN | 293070 | 2 | 0 | 10 | 0 | 0 | 2532387 | 3 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 9 | NaN | 43700000 | 293070 | 1956-06-04 | 1 | 0 | 0 | 480.07 | 74.62 | 2008-01-17 | J152 | NaN | 293070 | 7 | 0 | 10 | 0 | 0 | 2532387 | 3 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
Last rows
| CGC_HOSP | CEP | MUNIC_RES | NASC | SEXO | UTI_MES_TO | UTI_INT_TO | VAL_SH | VAL_SP | DT_INTER | DIAG_PRINC | DIAG_SECUN | MUNIC_MOV | DIAS_PERM | MORTE | NACIONAL | INSTRU | INSC_PN | CNES | RACA_COR | ETNIA | DIAGSEC1 | DIAGSEC2 | DIAGSEC3 | DIAGSEC4 | DIAGSEC5 | DIAGSEC6 | DIAGSEC7 | DIAGSEC8 | DIAGSEC9 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 168110 | NaN | 43700000 | 293070 | 2019-02-03 | 3 | 0 | 0 | 504.07 | 78.35 | 2020-01-08 | J180 | 0000 | 293070 | 4 | 0 | 10 | 0 | 0 | 2532387 | 3 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 168111 | NaN | 43700000 | 293070 | 2019-12-13 | 3 | 0 | 0 | 160.62 | 26.51 | 2020-01-10 | J219 | 0000 | 293070 | 2 | 0 | 10 | 0 | 0 | 2532387 | 3 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 168112 | NaN | 43700000 | 293070 | 2014-03-13 | 3 | 0 | 0 | 552.64 | 89.96 | 2020-01-08 | J180 | 0000 | 293070 | 11 | 0 | 10 | 0 | 0 | 2532387 | 3 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 168113 | NaN | 43700000 | 293070 | 2014-05-21 | 1 | 0 | 0 | 504.07 | 78.35 | 2020-01-10 | J180 | 0000 | 293070 | 6 | 0 | 10 | 0 | 0 | 2532387 | 3 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 168114 | NaN | 43700000 | 293070 | 1984-08-19 | 3 | 0 | 0 | 275.86 | 40.96 | 2019-12-25 | J030 | 0000 | 293070 | 2 | 0 | 10 | 0 | 0 | 2532387 | 99 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 168115 | NaN | 43700000 | 293070 | 2017-03-12 | 1 | 0 | 0 | 453.48 | 25.71 | 2020-01-16 | J459 | 0000 | 293070 | 5 | 0 | 10 | 0 | 0 | 2532387 | 3 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 168116 | NaN | 43700000 | 293070 | 2018-11-08 | 3 | 0 | 0 | 504.07 | 78.35 | 2020-01-17 | J180 | 0000 | 293070 | 4 | 0 | 10 | 0 | 0 | 2532387 | 3 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 168117 | NaN | 43700000 | 293070 | 2019-08-25 | 1 | 0 | 0 | 160.62 | 26.51 | 2020-01-17 | J219 | 0000 | 293070 | 6 | 0 | 10 | 0 | 0 | 2532387 | 3 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 168118 | NaN | 43700000 | 293070 | 1955-08-21 | 1 | 0 | 0 | 504.07 | 78.35 | 2020-01-05 | J180 | 0000 | 293070 | 3 | 0 | 10 | 0 | 0 | 2532387 | 3 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 168119 | NaN | 43700000 | 293070 | 1944-04-22 | 1 | 0 | 0 | 504.07 | 78.35 | 2020-01-04 | J180 | 0000 | 293070 | 5 | 0 | 10 | 0 | 0 | 2532387 | 3 | 0.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |